Accounts Receivable tables Version

Overview of Accounts Receivable tables

Accounts Receivable contains tables where you can record and maintain information that you use to create invoices, apply receipts, and perform other AR activities.
The Accounts Receivable tables include:

When you begin to use Accounts Receivable, you or your system administrator will need to enter information in your AR tables.
Accounts Payable and Materials Management also contain tables, and the information in some of those is used by Accounts Receivable as well.
Other table records are unique for just AP or just MM.

To edit a table row:

  1. From the main AR contents, select Tables -> [table name].

  2. Locatethe row in the table that you wish to edit. Click the pencil icon (or select Menu -> Edit).

  3. Make any changes as needed.
    - Click Help for information about fields on the Edit page.

  4. When you are finished, click Submit. The application returns you to the table.

  5. ClickRefresh to see the changes you made.


List of AR Tables

Action Codes

AR generates tasks that are called action items.
These action items must be completed by an individual, such as a collector or a credit manager.
An action item is assigned to a user, given a priority level, and contains a completion date.
Action items work together with events that are generated by the application.
Action items are created by the applction based on Action Codes, defined by the user in the Action Codes table.


AR Aging Profiles

The Aging Profiles table contains the different profiles your site uses for aging invoices.
Each profile specifies the aging basis (invoicedue date, invoice date, etc.) and the aging options.


AR Charge Types

This table lists the charge types used by the application, and a description of each type.


AR Analysis Codes

This table lists the AR Analysis Codes used by the application, and a description of each code.


Application Methods

You can apply cash in the AR system by using one of these application methods:


Banks

The Banks table contains information about the banks and associated bank accounts used at your site for making payments.

Using the Accounts Receivable module allows any customer to be associated with any bank or necessary lockbox.


Calendars

Calendars define fiscal years and accounting periods within fiscal years.
You can set up both AP and Materials Management calendars.


Collection Reason Codes

This table lists the Collection Reason Codes used by the application, and a description of each code.


Currency

The Currency table contains the list of national currencies that your site may use (Dollars, Euros, etc.).


Customer Classes

This table lists the Customer Classes used by the application, and a description of each class.


Discount Terms

A Discount Terms record contains up to three discount schedules that you can associate with AR Customers.
For example:

5% within 10 days.
2% within 30 days.
1% within 45 days.

You can create new discount terms in the table as needed.


Event Classes

This table lists the Event Classes used by the application, and a description of each class.


Events

In Accounts Receivable, an event is an occurrence that changes strategic data within the application, such as a new customer being added or a customer exceeding its credit limit.
Events are pre-defined by the application; however, you can create parameters around an event for additional control.

The event lets you define:

The event monitor is a unique capability that continuously monitors events occurring within the application and triggers appropriate actions.
For example, if a customer's balance becomes past due, a letter is sent to the customer requesting payment.

Accounts Receivable combines action items, events, and the event monitor to close the workflow loop for your organization.


Finance Charges

This table lists the Finance Charges used by the application, a description of each charge, and various Finance Charge settings.


GL Accounts

The GL Accounts table contains a list of accounts from the General Ledger relevant to the AR process.
For example: Freight, Tax Expense, etc.
Information for each account includes the account code, a description of the account, the type of account (expense, liability, asset, or income), the status of the account (active or suspended), and the organization that owns the account.


GL Transactions

Shows GL transactions and the source of each transaction, among other details.


Late Charges

This table lists the Late Charges used by the application, a description of each charge, and various Late Charge settings.


Letters

Accounts Receivable enables you to send dunning letters either:

The letters can be created within the AR module or exported to a PDF document.


Organizations

In Accounts Receivable, an organization is a business unit that typically incurs its own transactions, has its own bank accounts and General Ledger receivables accounts, and corresponds to a particular General Ledger profit center.

Accounts Receivable supports multiple organizations. One organization can be different from another.
Each organization can have different methods of operation, such as periods per year, GL posting policies, methods for applying receipts, and other policies.

This table contains information for all the organizations at your site.
To edit an organization's information, or create a new one, see Identify Administrative and Operational Units


Pay Tos

This table lists the Pay To entities used by the application, and details for each one:


Payment Terms

Payment terms are a payment schedule - an agreement between a paying organization and a vendor.
Your site may have several sets of payment terms for different vendors and organizations.
Once you define a set of payment terms in this table, you can associate the terms with any vendor who offers them.


Product Codes

This table lists the Product Codes used by the application, and details for each one.


Reason Codes

This table lists the Reason Codes used by the application, and details for each one.


Risk Codes

This table lists the Risk Codes used by the application, and details for each one.


Sales Person

This table lists the Sales Persons assigned to Customers, and details for each one.


Statement Types

In AR there are two Statement Types:

For AR, a statement consists of a listing that contains all the customer's outstanding items.

In preparation for an automatic statement run, you can:


Tax Rates

Lists the tax rates used by taxable organizations and AR customers.
Tax Rates are normally grouped in Tax Groups.


Tax Groups

Tax Groups contain multiple tax rates that may apply to particular transactions.
For example, a tax group may contain state, city, and local tax rates, all applicable to invoices for a particular AR Customer.


Units of Measure

This table contains all the units of measure used at your site; for example, EA - Each.